Sales Transaction Amounts Work (SOP10200)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Amounts Work (SOP10200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP10200

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Transaction Amounts Work
Physical Name: SOP10200
Technical Name: SOP_LINE_WORK

Group Display Name: Sales Work
Group Technical Name: Sales Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
2SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
3LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
4CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
5ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].ITEMNMBR AS 'Sales Transaction Amounts Work-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Sales Transaction Amounts Work'].ITEMNMBR = ['Item Master'].ITEMNMBR
6ITEMDESC SearchItem DescriptionStringSTR100100
7NONINVEN SearchNon IVIntegerINT11
Used to indicate whether an item is an inventory item or non-inventory item.

Click to show/hide PO Line Statuses

0	Inventory item
1	Non-inventory item
8DROPSHIP SearchDrop ShipIntegerINT22
9UOFM SearchU Of MStringU_Of_M8
The unit of measure. The value in this field must exist in Inventory.
10LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].LOCNCODE AS 'Sales Transaction Amounts Work-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Sales Transaction Amounts Work'].LOCNCODE = ['Site Setup'].LOCNCODE
11UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
12ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
13UNITPRCE SearchUnit PriceCurrencyDLR17_RBS0_STR$17
14ORUNTPRC SearchOriginating Unit PriceCurrencyDLR17_RBS0_STR$17
15XTNDPRCE SearchExtended PriceCurrencyDLR17_RBS0_STR$17
16OXTNDPRC SearchOriginating Extended PriceCurrencyDLR17_RBS0_STR$17
17REMPRICE SearchRemaining PriceCurrencyDLR17_RBS0_UTR$17
18OREPRICE SearchOriginating Remaining PriceCurrencyDLR17_RBS0_UTR$17
19EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
20OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
21MRKDNAMT SearchMarkdown AmountCurrencyDLR17_RBS0_UTR$17
22ORMRKDAM SearchOriginating Markdown AmountCurrencyDLR17_RBS0_UTR$17
23MRKDNPCT SearchMarkdown PercentIntegerINT5_%25
24MRKDNTYP SearchMarkdown TypeIntegerGB0
25INVINDX SearchInventory IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].INVINDX AS 'Sales Transaction Amounts Work-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].INVINDX = ['Account Index Master'].ACTINDX
26CSLSINDX SearchCost Of Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].CSLSINDX AS 'Sales Transaction Amounts Work-Cost Of Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].CSLSINDX = ['Account Index Master'].ACTINDX
27SLSINDX SearchSales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].SLSINDX AS 'Sales Transaction Amounts Work-Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].SLSINDX = ['Account Index Master'].ACTINDX
28MKDNINDX SearchMarkdown IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].MKDNINDX AS 'Sales Transaction Amounts Work-Markdown Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].MKDNINDX = ['Account Index Master'].ACTINDX
29RTNSINDX SearchReturns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].RTNSINDX AS 'Sales Transaction Amounts Work-Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].RTNSINDX = ['Account Index Master'].ACTINDX
30INUSINDX SearchIn Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].INUSINDX AS 'Sales Transaction Amounts Work-In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].INUSINDX = ['Account Index Master'].ACTINDX
31INSRINDX SearchIn Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].INSRINDX AS 'Sales Transaction Amounts Work-In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].INSRINDX = ['Account Index Master'].ACTINDX
32DMGDINDX SearchDamaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].DMGDINDX AS 'Sales Transaction Amounts Work-Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].DMGDINDX = ['Account Index Master'].ACTINDX
33ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].ITMTSHID AS 'Sales Transaction Amounts Work-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Amounts Work'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
34IVITMTXB SearchIV Item TaxableIntegerDDL_Tax_Options0
35BKTSLSAM SearchBackout Sales AmountCurrencyDLR19_RBS0_UTR$19
36ORBKTSLS SearchOriginating Backout Sales AmountCurrencyDLR19_RBS0_UTR$19
37TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
38ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
39TXBTXAMT SearchTaxable Tax AmountCurrencyDLR19_RBSO_UTR$19
40OTAXTAMT SearchOriginating Taxable Tax AmountCurrencyDLR17_RBS0_UTR$17
41BSIVCTTL SearchBased On Invoice TotalBooleanYN0
42TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
43ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
44DISCSALE SearchDiscount Available SalesCurrencyDLR17_RBS0_UTR$17
45ORDAVSLS SearchOriginating Discount Available SalesCurrencyDLR17_RBS0_UTR$17
46QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
47ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
48QTYINSVC SearchQTY In ServiceCurrencyDLR17_QTY_RBS0_UTR17
49QTYINUSE SearchQTY In UseCurrencyDLR17_QTY_RBS0_UTR17
50QTYDMGED SearchQTY DamagedCurrencyDLR17_QTY_RBS0_UTR17
51QTYRTRND SearchQTY ReturnedCurrencyDLR17_QTY_RBS0_UTR17
52QTYONHND SearchQTY On HandCurrencyDLR17_QTY_RBS0_STR17
53QTYCANCE SearchQTY CanceledCurrencyDLR17_QTY_RBS0_UTR17
54QTYCANOT SearchQTY Canceled OtherCurrencyDLR17_QTY_RBS0_UTR17
55QTYONPO SearchQTY On POCurrencyDLR17_QTY_RBS0_UTR17
56QTYORDER SearchQTY OrderedCurrencyDLR17_QTY_RBS0_UTR17
57QTYPRBAC SearchQTY Prev Back OrderedCurrencyDLR17_QTY_RBS0_UTR17
58QTYPRBOO SearchQTY Prev BO On OrderCurrencyDLR17_QTY_RBS0_UTR17
59QTYPRINV SearchQTY Prev InvoicedCurrencyDLR17_QTY_RBS0_UTR17
60QTYPRORD SearchQTY Prev OrderedCurrencyDLR17_QTY_RBS0_UTR17
61QTYPRVRECVD SearchQTY Prev ReceivedCurrencyDLR17_QTY_RBS0_UTR17
62QTYRECVD SearchQTY ReceivedCurrencyDLR17_QTY_RBS0_UTR17
63QTYREMAI SearchQTY RemainingCurrencyDLR17_QTY_RBS0_UTR17
64QTYREMBO SearchQTY Remaining On BOCurrencyDLR17_QTY_RBS0_UTR17
65QTYTBAOR SearchQTY To Back OrderCurrencyDLR17_QTY_RBS0_UTR17
66QTYTOINV SearchQTY To InvoiceCurrencyDLR17_QTY_RBS0_UTR17
67QTYTORDR SearchQTY To OrderCurrencyDLR17_QTY_RBS0_UTR17
68QTYFULFI SearchQTY FulfilledCurrencyDLR17_QTY_RBS0_UTR17
69QTYSLCTD SearchQTY SelectedCurrencyDLR17_QTY_RBS0_UTR17
70QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
71EXTQTYAL SearchExisting Qty AvailableCurrencyDLR17_RBS0_UTR$17
72EXTQTYSEL SearchExisting Qty SelectedCurrencyDLR17_QTY_RBS0_STR17
73ReqShipDate SearchRequested Ship DateDateDT8
74FUFILDAT SearchFulfillment DateDateDT8
75ACTLSHIP SearchActual Ship DateDateDT8
76SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].SHIPMTHD AS 'Sales Transaction Amounts Work-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Sales Transaction Amounts Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
77SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].SALSTERR AS 'Sales Transaction Amounts Work-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Sales Transaction Amounts Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR
78SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].SLPRSNID AS 'Sales Transaction Amounts Work-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Transaction Amounts Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
79PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
80COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].COMMNTID AS 'Sales Transaction Amounts Work-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Sales Transaction Amounts Work'].COMMNTID = ['Comment Master'].COMMNTID
81BRKFLD1 SearchBreak Field 1IntegerINT11
82BRKFLD2 SearchBreak Field 2IntegerINT11
83BRKFLD3 SearchBreak Field 3IntegerINT11
84CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].CURRNIDX AS 'Sales Transaction Amounts Work-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Transaction Amounts Work'].CURRNIDX = ['Currency Setup'].CURRNIDX
85TRXSORCE SearchTRX SourceStringSTR1313
86SOPLNERR SearchSOP LINE ErrorsLong IntegerML_SOP_LINE_Errors0
87ORGSEQNM SearchOriginal Sequence Number CorrectedLong IntegerLI_Sequence_Number10
88ITEMCODE SearchItem CodeStringSTR1515
89PURCHSTAT SearchPurchasing StatusIntegerDDL_PurchasingStatus0
90DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
91DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
92ODECPLCU SearchOriginating Decimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
93QTYTOSHP SearchQTY To ShipCurrencyDLR17_QTY_RBS0_UTR17
94XFRSHDOC SearchTransferred To Shipping DocumentBooleanBoolean0
95EXCEPTIONALDEMAND SearchExceptional DemandBooleanCB_Exceptional_Demand0
96TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].TAXSCHID AS 'Sales Transaction Amounts Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Amounts Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
97TXSCHSRC SearchTax Schedule SourceIntegerINT11
98PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
99ShipToName SearchShipToNameStringSTR64_Customer_Name64
100CNTCPRSN SearchContact PersonStringSTR6060
101ADDRESS1 SearchAddress 1StringSTR6060
102ADDRESS2 SearchAddress 2StringSTR6060
103ADDRESS3 SearchAddress 3StringSTR6060
104CITY SearchCityStringSTR3535
105STATE SearchStateStringSTR30_State29
106ZIPCODE SearchZip CodeStringSTR1010
107CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].CCode AS 'Sales Transaction Amounts Work-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Sales Transaction Amounts Work'].CCode = ['VAT Country Code MSTR'].CCode
108COUNTRY SearchCountryStringSTR6060
109PHONE1 SearchPhone 1StringPhone_Number14
110PHONE2 SearchPhone 2StringPhone_Number14
111PHONE3 SearchPhone 3StringPhone_Number314
112FAXNUMBR SearchFax NumberStringSTR14_FAX14
113Flags SearchFlagsIntegerINT11
114BackoutTradeDisc SearchBackout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
115OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
116GPSFOINTEGRATIONID SearchGPSFO Integration IDStringSTR3030
117INTEGRATIONSOURCE SearchIntegration SourceIntegerINT0
118INTEGRATIONID SearchIntegration IDStringSTR3030
119CONTNBR SearchContract NumberStringSTR1111
120CONTLNSEQNBR SearchContract Line SEQ NumberCurrencySequence_Number19
121CONTSTARTDTE SearchContract Start DateDateDATE6
122CONTENDDTE SearchContract End DateDateDATE_L0
123CONTITEMNBR SearchContract Item NumberStringSTR30_Item_Number30
124CONTSERIALNBR SearchContract Serial NumberStringSTR20_LBAU20
125BULKPICKPRNT SearchBulk Pick PrintedBooleanBoolean0
126INDPICKPRNT SearchIndividual Pick PrintedBooleanBoolean0
127ISLINEINTRA SearchIsLineIntrastatBooleanCB0
128SOFULFILLMENTBIN SearchSO Fulfillment BinStringSTR15_Bin15
129MULTIPLEBINS SearchMultiple BinsBooleanCB0
130Print_Phone_NumberGB SearchPrint Phone Number GBIntegerGB0
azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Amounts Work (SOP10200)

Leave a Reply

Your email address will not be published. Required fields are marked *